package com.ruoyi.quartz.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.quartz.domain.YjgCgMain;
import org.apache.ibatis.annotations.Param;

/**
 * YjgCgMainMapper接口
 * 
 * @author SYF
 * @date 2025-05-07
 */
public interface YjgCgMainMapper 
{
    /**
     * 查询YjgCgMain
     * 
     * @param consigntime YjgCgMain主键
     * @return YjgCgMain
     */
    public YjgCgMain selectYjgCgMainByConsigntime(String consigntime);

    /**
     * 查询YjgCgMain列表
     * 
     * @param yjgCgMain YjgCgMain
     * @return YjgCgMain集合
     */
    public List<YjgCgMain> selectYjgCgMainList(YjgCgMain yjgCgMain);

    /**
     * 新增YjgCgMain
     * 
     * @param yjgCgMain YjgCgMain
     * @return 结果
     */
    public int insertYjgCgMain(YjgCgMain yjgCgMain);

    /**
     * 修改YjgCgMain
     * 
     * @param yjgCgMain YjgCgMain
     * @return 结果
     */
    public int updateYjgCgMain(YjgCgMain yjgCgMain);

    /**
     * 删除YjgCgMain
     * 
     * @param consigntime YjgCgMain主键
     * @return 结果
     */
    public int deleteYjgCgMainByConsigntime(String consigntime);

    /**
     * 批量删除YjgCgMain
     * 
     * @param consigntimes 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteYjgCgMainByConsigntimes(String[] consigntimes);

    public List<Map<String,Object>> selectJygDim();

    public List<Map<String,Object>> selectJygDimKc();

    public List<Map<String,Object>> selectJygDimInfo(@Param("year") String year);

    public List<Map<String,Object>> selectJygCgData();

    public List<Map<String,Object>> selectJygCgMainData();

    public int deleteDataByYear(@Param("year") String year);

    public int deleteCgImportYjgMainByYear(@Param("year") String year);

    public List<Map<String,Object>> selectJygXsData(@Param("year") String year);

    public List<Map<String,Object>> selectYjgCgMainData(@Param("year") String year);

    public List<Map<String,Object>> selectCgYjgMainData(@Param("year") String year);

    public List<Map<String,Object>> selectJygDqkcData();
}
